Release 10.1A: OpenEdge Data Management:
SQL Development

Comparing Progress 4GL and OpenEdge SQL

The Progress 4GL is a high-level procedural programming language, developed to enable you to build almost all aspects of an enterprise business application, from the user interface to database access and business logic.

The Progress 4GL can create and maintain the databases of OpenEdge 4GL applications. You can use Progress 4GL to access database objects created with SQL, but only if they are located in the SQL schema called PUB and contain data types recognized by the Progress 4GL.

OpenEdge SQL

OpenEdge SQL is a standards-based language used to create and maintain relational databases. OpenEdge SQL has the ability to retrieve, update, or delete data in a 4GL database. However, it cannot modify the structure of a 4GL database.